enq: SQ - contention

Short Description

Enqueue wait. Sequence Number Enqueue.

Additional Information

An enqueue is a wait for a resource held by another.

enq: SQ is seen when the next value is selected from a sequence.

Consider caching the sequence and adjusting the number is cached values to minimize the wait.

SQL> ALTER SEQUENCE cust_id CACHE 500;

Be aware that with cached sequences, sequence numbers will be lost at database shutdown/restart.

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.